Normalization Based on Dependency Diagram

L

The examination of the efficiency of the teaching of SQL

Based on the results of SQL tests and the number of trials we think that it is necessary to enhance students for practise. The results of the SQL tests and the exams are in line with the judgement of students. The mostly problematic topics are the grouping, the linking and the use of subquery. In these topics the introduction of teaching substances and practising tests proved to be useful, the result of those students who used these resources has proven to be significantly better. The analysis pointed out that during practising students would require a prompt feedback of correctness right after the editing of the SQL statements. We think that to introduce an SQL tutorial program into the education process would be useful here too

How Do the Engineer Students Learn the SQL Language?

In the teaching of database management the teaching of standardized SQL language cannot be avoided. Until the appearance of e-learning education systems we could only support the learning of SQL language with showing example queries. Using e-learning education systems in the education enables using tests, tutorials, teacher feedbacks which facilitate the learning of SQL language. But still these education tools can not ensure that students receive error message and assessment for correctness of the query edited in database management system in their native language after running the SQL query. In order to accomplish these two latter purposes we wrote a SQL tutoring system which was used from 2012â??s autumn by the students. In the paper we describe the problems of learning the SQL language, the supporting methods for learning before installation of the SQL tutoring system and with analysis of data of log file of the SQL tutoring system the manner of studentsâ?? learning of SQL